{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Sample","Template"],"not_rendered":{"external_links":2,"defined_names":189,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"merged":[[2,0,2,2]]}
["\nCHANGES FROM CAPITAL FORECAST TEMPLATE INSTRUCTIONS"]
[]
["This Excel template creates a high level summary in a standard format for presentation purposes. This information is required to ensure a consistent reporting format."]
[]
["GENERAL:"]
[null,"u","This summarizes the annual changes by project in the Capital Budget submission for 2016 to 2020 with the same period in the 2015 Adopted Capital Budget."]
[null,"u","If starting from scratch, type the department name into the yellow cell below, the department name will automatically be copied to the template tab."]
[null,"u","DEPARTMENT NAME"]
[null,"u","Data entry cells have been highlighted in yellow for ease of data entry.  Please do not enter any information into cells that are not yellow."]
[null,"u","Description cells are set to wrap, but row heights may need to be manually adjusted."]
[null,"u","Add or remove rows as needed for additions and deductions."]
[null,"u","Numbers to be rounded to thousands."]
[null,"u","The template will automatically calculate the submission based on \"net change\" you've entered."]
[null,"u","Assign an explanation number to all projects that have changes for 2016 to 2020.  Leave the explanation number blank if there is no variance."]
[null,"u","Use the separate Word template (2016 Changes from Capital Forecast - Narrative) to explain any variances."]
[]
[]
["PRINTING:"]
[null,"u","Print setups have been set up, minimal change should be required (i.e page breaks if needed). "]
[]
["QUESTIONS:"]
[null,null,"Please call your Financial Planning & Review Analyst with any questions related to this template."]
[null,null,"Grant Heather - 204-986-4325"]
[null,null,"Knight Morton - 204-986-2283"]
[null,null,"Ryan Marsh - 204-986-7525"]
[null,null,"Kerry Zakowich - 204-986-2128"]

{"sheet":"Sample","index":1,"n_rows":17,"n_cols":25,"rows_kept":17,"merged":[[3,37,3,39]]}
[]
[]
[]
[]
[null,"CAPITAL PROJECTS SUMMARY"]
[null,"CHANGES FROM CAPITAL FORECAST",null,2015,{"$f":"+D6+1","v":2016},{"$f":"+$E$6","v":2016},{"$f":"+$E$6","v":2016},{"$f":"+G6+1","v":2017},{"$f":"+$H$6","v":2017},{"$f":"+$H$6","v":2017},{"$f":"+$J$6+1","v":2018},{"$f":"+$J$6+1","v":2018},{"$f":"+$J$6+1","v":2018},{"$f":"+$M$6+1","v":2019},{"$f":"+$M$6+1","v":2019},{"$f":"+$M$6+1","v":2019},{"$f":"+$P$6+1","v":2020},{"$f":"+$P$6+1","v":2020},{"$f":"+$P$6+1","v":2020},{"$f":"+$S$6+1","v":2021},"2016-2020",{"$f":"+U6","v":"2016-2020"},{"$f":"+V6","v":"2016-2020"}]
[null,"(in Thousands of $)","EXPL.","ADOPTED ","FORECAST","TOTAL ","SUBMISSION","FORECAST","TOTAL ","SUBMISSION","FORECAST","TOTAL ","SUBMISSION","FORECAST","TOTAL ","SUBMISSION","FORECAST","TOTAL ","SUBMISSION","SUBMISSION","FORECAST","TOTAL ","SUBMISSION"]
[null,null,"NO.","BUDGET","ADOPTED ","CHANGES",null,"ADOPTED ","CHANGES",null,"ADOPTED ","CHANGES",null,"ADOPTED ","CHANGES",null,"ADOPTED ","CHANGES",null,null,"5 YEAR","CHANGES","5 YEAR"]
[{"$nulls":4},"BY",null,null,"BY",null,null,"BY",null,null,"BY",null,null,"BY",{"$nulls":3},"TOTAL",null,"TOTAL"]
[{"$nulls":4},"COUNCIL",null,null,"COUNCIL",null,null,"COUNCIL",null,null,"COUNCIL",null,null,"COUNCIL",{"$nulls":7},"CHECK"]
[null,"CAPITAL PROJECTS LISTING"]
[null,{"$f":"+Instructions!C8","v":"DEPARTMENT NAME"}]
[null,"Developer Payback - ABC Street",{"v":1,"d":"1 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"$f":"+E13+F13","v":{"v":2000,"d":"2,000 "}},{"v":0,"d":"0 "},null,{"$f":"+H13+I13","v":{"v":0,"d":"0 "}},{"v":2000,"d":"2,000 "},null,{"$f":"+K13+L13","v":{"v":2000,"d":"2,000 "}},null,null,{"$f":"+N13+O13","v":{"v":0,"d":"0 "}},null,null,{"$f":"+Q13+R13","v":{"v":0,"d":"0 "}},null,{"$f":"+E13+H13+K13+N13+Q13","v":{"v":3000,"d":"3,000 "}},{"$f":"F13+I13+L13+O13+R13","v":{"v":1000,"d":"1,000 "}},{"$f":"+G13+J13+M13+P13+S13","v":{"v":4000,"d":"4,000 "}},null,{"$f":"+W13-U13-V13","v":{"v":0,"d":"0 "}}]
[null,"Regional and Local Streets",{"v":2,"d":"2 "},{"v":1000,"d":"1,000 "},{"v":5000,"d":"5,000 "},{"v":-1200,"d":"(1,200)"},{"$f":"+E14+F14","v":{"v":3800,"d":"3,800 "}},{"v":0,"d":"0 "},null,{"$f":"+H14+I14","v":{"v":0,"d":"0 "}},{"v":2500,"d":"2,500 "},{"v":200,"d":"200 "},{"$f":"+K14+L14","v":{"v":2700,"d":"2,700 "}},null,null,{"$f":"+N14+O14","v":{"v":0,"d":"0 "}},{"v":2000,"d":"2,000 "},null,{"$f":"+Q14+R14","v":{"v":2000,"d":"2,000 "}},null,{"$f":"+E14+H14+K14+N14+Q14","v":{"v":9500,"d":"9,500 "}},{"$f":"F14+I14+L14+O14+R14","v":{"v":-1000,"d":"(1,000)"}},{"$f":"+G14+J14+M14+P14+S14","v":{"v":8500,"d":"8,500 "}},null,{"$f":"+W14-U14-V14","v":{"v":0,"d":"0 "}}]
[null,"Bridge XX",{"v":3,"d":"3 "},{"v":1000,"d":"1,000 "},{"v":1300,"d":"1,300 "},{"v":1500,"d":"1,500 "},{"$f":"+E15+F15","v":{"v":2800,"d":"2,800 "}},null,null,{"$f":"+H15+I15","v":{"v":0,"d":"0 "}},{"v":7000,"d":"7,000 "},{"v":0,"d":"0 "},{"$f":"+K15+L15","v":{"v":7000,"d":"7,000 "}},{"v":6000,"d":"6,000 "},null,{"$f":"+N15+O15","v":{"v":6000,"d":"6,000 "}},null,{"v":0,"d":"0 "},{"$f":"+Q15+R15","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"$f":"+E15+H15+K15+N15+Q15","v":{"v":14300,"d":"14,300 "}},{"$f":"F15+I15+L15+O15+R15","v":{"v":1500,"d":"1,500 "}},{"$f":"+G15+J15+M15+P15+S15","v":{"v":15800,"d":"15,800 "}},null,{"$f":"+W15-U15-V15","v":{"v":0,"d":"0 "}}]
[null,"Parks",null,{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},null,{"$f":"+E16+F16","v":{"v":1000,"d":"1,000 "}},{"$nulls":13},{"$f":"+E16+H16+K16+N16+Q16","v":{"v":1000,"d":"1,000 "}},{"$f":"F16+I16+L16+O16+R16","v":{"v":0,"d":"0 "}},{"$f":"+G16+J16+M16+P16+S16","v":{"v":1000,"d":"1,000 "}}]
[null,"Total Department Name",null,{"$f":"SUM(D13:D16)","v":{"v":4000,"d":"4,000 "}},{"v":8300,"d":"8,300 "},{"v":1300,"d":"1,300 "},{"v":9600,"d":"9,600 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":11500,"d":"11,500 "},{"v":200,"d":"200 "},{"v":11700,"d":"11,700 "},{"v":6000,"d":"6,000 "},{"v":0,"d":"0 "},{"v":6000,"d":"6,000 "},{"v":2000,"d":"2,000 "},{"v":0,"d":"0 "},{"v":2000,"d":"2,000 "},{"v":0,"d":"0 "},{"$f":"SUM(U13:U16)","v":{"v":27800,"d":"27,800 "}},{"$f":"SUM(V13:V16)","v":{"v":1500,"d":"1,500 "}},{"$f":"SUM(W13:W16)","v":{"v":29300,"d":"29,300 "}},null,{"$f":"+W17-U17-V17","v":{"v":0,"d":"0 "}}]

{"sheet":"Template","index":2,"n_rows":11,"n_cols":25,"rows_kept":11}
[null,"CHANGES FROM CAPITAL FORECAST",null,2015,{"$f":"+D1+1","v":2016},{"$f":"+$E$1","v":2016},{"$f":"+$E$1","v":2016},{"$f":"+G1+1","v":2017},{"$f":"+$H$1","v":2017},{"$f":"+$H$1","v":2017},{"$f":"+$J$1+1","v":2018},{"$f":"+$J$1+1","v":2018},{"$f":"+$J$1+1","v":2018},{"$f":"+$M$1+1","v":2019},{"$f":"+$M$1+1","v":2019},{"$f":"+$M$1+1","v":2019},{"$f":"+$P$1+1","v":2020},{"$f":"+$P$1+1","v":2020},{"$f":"+$P$1+1","v":2020},{"$f":"+$S$1+1","v":2021},"2016-2020",{"$f":"U1","v":"2016-2020"},{"$f":"+V1","v":"2016-2020"}]
[null,"(in Thousands of $)","EXPL.","ADOPTED ","FORECAST","TOTAL ","SUBMISSION","FORECAST","TOTAL ","SUBMISSION","FORECAST","TOTAL ","SUBMISSION","FORECAST","TOTAL ","SUBMISSION","FORECAST","TOTAL ","SUBMISSION","SUBMISSION","FORECAST","TOTAL ","SUBMISSION"]
[null,null,"NO.","BUDGET","ADOPTED ","CHANGES",null,"ADOPTED ","CHANGES",null,"ADOPTED ","CHANGES",null,"ADOPTED ","CHANGES",null,"ADOPTED ","CHANGES",null,null,"5 YEAR","CHANGES","5 YEAR"]
[{"$nulls":4},"BY",null,null,"BY",null,null,"BY",null,null,"BY",null,null,"BY",{"$nulls":3},"TOTAL",null,"TOTAL"]
[{"$nulls":4},"COUNCIL",null,null,"COUNCIL",null,null,"COUNCIL",null,null,"COUNCIL",null,null,"COUNCIL",{"$nulls":7},"CHECK"]
[null,"CAPITAL PROJECTS LISTING"]
[null,{"$f":"+Instructions!C8","v":"DEPARTMENT NAME"}]
[null,"Project 1",{"$nulls":4},{"$f":"+E8+F8","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},null,{"$f":"+H8+I8","v":{"v":0,"d":"0 "}},null,null,{"$f":"+K8+L8","v":{"v":0,"d":"0 "}},null,null,{"$f":"+N8+O8","v":{"v":0,"d":"0 "}},null,null,{"$f":"+Q8+R8","v":{"v":0,"d":"0 "}},null,{"$f":"+E8+H8+K8+N8+Q8","v":{"v":0,"d":"0 "}},{"$f":"F8+I8+L8+O8+R8","v":{"v":0,"d":"0 "}},{"$f":"+G8+J8+M8+P8+S8","v":{"v":0,"d":"0 "}},null,{"$f":"+W8-U8-V8","v":{"v":0,"d":"0 "}}]
[null,"Project 2",{"$nulls":4},{"$f":"+E9+F9","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},null,{"$f":"+H9+I9","v":{"v":0,"d":"0 "}},null,null,{"$f":"+K9+L9","v":{"v":0,"d":"0 "}},null,null,{"$f":"+N9+O9","v":{"v":0,"d":"0 "}},null,null,{"$f":"+Q9+R9","v":{"v":0,"d":"0 "}},null,{"$f":"+E9+H9+K9+N9+Q9","v":{"v":0,"d":"0 "}},{"$f":"F9+I9+L9+O9+R9","v":{"v":0,"d":"0 "}},{"$f":"+G9+J9+M9+P9+S9","v":{"v":0,"d":"0 "}},null,{"$f":"+W9-U9-V9","v":{"v":0,"d":"0 "}}]
[null,"Project 3",{"$nulls":4},{"$f":"+E10+F10","v":{"v":0,"d":"0 "}},null,null,{"$f":"+H10+I10","v":{"v":0,"d":"0 "}},null,null,{"$f":"+K10+L10","v":{"v":0,"d":"0 "}},null,null,{"$f":"+N10+O10","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"$f":"+Q10+R10","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"$f":"+E10+H10+K10+N10+Q10","v":{"v":0,"d":"0 "}},{"$f":"F10+I10+L10+O10+R10","v":{"v":0,"d":"0 "}},{"$f":"+G10+J10+M10+P10+S10","v":{"v":0,"d":"0 "}},null,{"$f":"+W10-U10-V10","v":{"v":0,"d":"0 "}}]
[null,"Total Department Name",null,{"$f":"SUM(D8:D10)","v":{"v":0,"d":"0 "}},{"$f":"SUM(E8:E10)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,{"$f":"+W11-U11-V11","v":{"v":0,"d":"0 "}}]